﻿CREATE PROCEDURE [dbo].[kp_GetNextValueAutoNumber]
	@Name [Nvarchar](32)	
AS
BEGIN
	Update [tblAutoNumber] set [Value]=[Value]+[Seed],[LastModified]=Getdate() where [Name]=@Name
	Select [Value] from [tblAutoNumber] where [Name]=@Name	
	RETURN 0;
END